<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10" interactivePageBreakByFrame="true"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 17:58:18-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Violation Trends and Status</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Violation Count</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Violations">
			<contents><textItem><dataSource><dataItemValue refDataItem="Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Path Outage Count</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton2" refQuery="Path Outage Trend">
			<contents><textItem><dataSource><dataItemValue refDataItem="Total Violations"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Capacity Violations</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton4" refQuery="Storage Pool Capacity Violations">
			<contents><textItem><dataSource><dataItemValue refDataItem="Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Latency Violations</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton5" refQuery="Volume Performance Violations">
			<contents><textItem><dataSource><dataItemValue refDataItem="Volume Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Slow Drain Violations</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton6" refQuery="Switch Perf">
			<contents><textItem><dataSource><dataItemValue refDataItem="Slow Drain Device Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px;border-right:2px solid #ADB2B5"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Failed Data Sources</staticValue></dataSource></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px;font-family:Arial;font-size:14px;color:#656565"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><singleton name="Singleton3" refQuery="Failed Data Source Count">
			<contents><textItem><dataSource><dataItemValue refDataItem="Failed Count"/></dataSource><style><CSS value="font-family:Arial;font-size:36px;font-weight:bold;color:#808080"/></style></textItem></contents>
		</singleton></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="padding-left:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:30px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Path Violations</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:#F7F7F7;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Violation Count Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(Description)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart7" refQuery="Violation Count and Time Frame">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Month Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Month Number"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Violation Count"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:400px;height:115px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Violation Count</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Type)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Violations" name="Combination Chart8" depth="9">
																																						<v2_combinationTypeTooltips/>
																																						<v2_legend>
																																							<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																																						<v2_commonAxis>
																																							<v2_ordinalAxis>
																																								<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																																						</v2_commonAxis>
																																						<v2_topLeftAxis>
																																							<v2_combinationChartTypes>
																																								<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																									<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Count"><chartContents><chartTextItem><dataSource><staticValue/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																																							</v2_combinationChartTypes>
																																							<v2_axis>
																																								<v2_axisRange>
																																									<v2_automaticRange/>
																																								</v2_axisRange>
																																								<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																						</v2_topLeftAxis>
																																						<style>
																																							<CSS value="width:400px;height:115px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																						</v2_combinationChart>
																																				</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Violation Count</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Storage)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Violations" name="Combination Chart15" depth="9">
	<v2_combinationTypeTooltips/>
	
	<v2_commonAxis>
		<v2_ordinalAxis>
			<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Count"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
				<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Count"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
			<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
	</v2_topLeftAxis>
	<style>
		<CSS value="width:400px;height:125px;color:#454545;font-size:8pt"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
	
	</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Path Outage Trend</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart16" refQuery="Path Outage Trend">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Month Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Month Number"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Violation Count"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:400px;height:125px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes><v2_defaultChartMeasure refDataItem="Total Violations"/><v2_notes><v2_note refQuery="Path Outage Trend"><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>No Path Outages to Trend</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems><style><CSS value="font-family:Arial;font-size:24px;color:#DBDBDB;font-weight:bold"/></style><conditionalRender refVariable="showPathOutageNote"><renderFor refVariableValue="1"/></conditionalRender><v2_constrainedPosition><v2_verticalPosition><v2_middle offset="0px"/></v2_verticalPosition><v2_horizontalPosition><v2_center offset="0px"/></v2_horizontalPosition><v2_positionAnchor><v2_relativeChart/></v2_positionAnchor></v2_constrainedPosition></v2_note></v2_notes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:5px;padding-left:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Impacted by Violations</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart5" refQuery="Violation Capacity Trends">
                                                                                                        <v2_combinationTypeTooltips/>
                                                                                                        <v2_commonAxis>
                                                                                                            <v2_ordinalAxis>
                                                                                                                <v2_axisLine lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                            </v2_ordinalAxis>
                                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Month Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Month Number"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                                        <v2_topLeftAxis>
                                                                                                            <v2_combinationChartTypes>
                                                                                                                <v2_area lineAreaShape="smooth" seriesType="stacked">
                                                                                                                    <v2_solidPalette>
                                                                                                                        
                                                                                                                    <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                                                    <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                                                <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity (GB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
                                                                                                            </v2_combinationChartTypes>
                                                                                                            <v2_axis>
                                                                                                                <v2_axisRange>
                                                                                                                    <v2_automaticRange/>
                                                                                                                </v2_axisRange>
                                                                                                                <v2_axisLabels>
                                                                                                                    <style>
                                                                                                                        <defaultStyles>
                                                                                                                            <defaultStyle refStyle="al"/>
                                                                                                                        </defaultStyles>
                                                                                                                    <dataFormat><numberFormat pattern="###,### TB"/></dataFormat><CSS value="color:#454545"/></style>
                                                                                                                </v2_axisLabels>
                                                                                                                <v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
                                                                                                            </v2_axis>
                                                                                                        </v2_topLeftAxis>
                                                                                                        <style>
                                                                                                            <defaultStyles>
                                                                                                                <defaultStyle refStyle="ch"/>
                                                                                                            </defaultStyles>
                                                                                                            <CSS value="width:400px;height:115px;font-family:Arial"/></style>
                                                                                                        
                                                                                                        <XMLAttributes><XMLAttribute name="titlesExpanded" output="no" value="true"/></XMLAttributes></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Capacity Impact</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart17" refQuery="Violations" depth="9">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="8" truncationText="...">
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Capacity GB"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar borderColor="white" barShape="box">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Capacity GB"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="width:400px;height:115px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-top:5px;padding-left:5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;vertical-align:top;background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:#F7F7F7;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center;background-color:#F7F7F7"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Performance Violations</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:#F7F7F7;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%;height:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Latency Violations</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(&gt; 50 ms)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart18" refQuery="Volume Performance Violations" depth="9">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="8" truncationText="...">
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Latency"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar borderColor="white" barShape="box">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Latency"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="### ms"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="### ms"/></dataFormat></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="width:825px;height:140px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Slow Drain Violations</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(bbCreditZero &gt; 1,000,000)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Switch Perf" name="Combination Chart19" depth="9">
																																												<v2_combinationTypeTooltips/>
																																												<v2_commonAxis>
																																													<v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="8" truncationText="...">
																																														<v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels></v2_ordinalAxis>
																																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Connected Device"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="bbCreditZeroTotal"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																												<v2_topLeftAxis>
																																													<v2_combinationChartTypes>
																																														<v2_bar borders="hide" borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																															<v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="bbCreditZeroTotal"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,### M"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																																													</v2_combinationChartTypes>
																																													<v2_axis>
																																														<v2_axisRange>
																																															<v2_automaticRange/>
																																														</v2_axisRange>
																																														<v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,###,### Mil"/></dataFormat></style>
                                                                                        </v2_axisLabels><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
																																												</v2_topLeftAxis>
																																												<style>
																																													<CSS value="width:825px;height:140px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																												<noDataHandler>
																																													<contents>
																																														<block>
																																															<contents>
																																																<textItem>
																																																	<dataSource>
																																																		<staticValue>No Data Available</staticValue>
																																																	</dataSource>
																																																	<style>
																																																		<CSS value="padding:10px 18px;"/>
																																																	</style>
																																																</textItem>
																																															</contents>
																																														</block>
																																													</contents>
																																												</noDataHandler>
																																												<chartSuppress type="categories"/></v2_combinationChart>
																																										</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:#F7F7F7;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center;background-color:#F7F7F7"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Capacity Violations</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:5px;background-color:#F7F7F7"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:#F7F7F7;text-align:center"/></style></tableCell><tableCell><contents>
																														<table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Over-Commited Thin Pools</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart12" refQuery="Capacity Thresholds Thin" depth="9">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="12" truncationText="...">
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Storage Name"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Thin Allocated/Committed (%)"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar borderColor="white" barShape="box">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <v2_chartDataLabels displayDataLocation="centered" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Thin Allocated/Committed (%)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="width:435px;height:140px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Storage Pool Capacity Violations</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart13" refQuery="Storage Pool Capacity Violations" depth="9">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="12" truncationText="...">
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Pool"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar borderColor="white" barShape="box">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <v2_chartDataLabels displayDataLocation="centered" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="% Used"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><percentFormat/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <dataFormat><percentFormat/></dataFormat><CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="width:435px;height:140px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>High Fan Out</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Array)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" name="Combination Chart14" refQuery="High Fan Out" depth="9">
                                                                                <v2_combinationTypeTooltips/>
                                                                                <v2_commonAxis>
                                                                                    <v2_ordinalAxis autoTruncation="false" manualTruncationMaxChars="12" truncationText="...">
                                                                                        
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                            <CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                    </v2_ordinalAxis>
                                                                                    <chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="StorageName"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Fan Out"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
                                                                                <v2_topLeftAxis>
                                                                                    <v2_combinationChartTypes>
                                                                                        <v2_bar borderColor="white" barShape="box">
                                                                                            <v2_solidPalette>
                                                                                                <v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
                                                                                            <!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
                                                                                            <v2_chartDataLabels displayDataLocation="centered" labelCollisionMode="fine_stagger" labelValueType="absolute" leaderLines="hide"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Fan Out"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
                                                                                    </v2_combinationChartTypes>
                                                                                    <v2_axis>
                                                                                        <v2_axisLabels>
                                                                                            <style>
                                                                                                <defaultStyles>
                                                                                                    <defaultStyle refStyle="al"/>
                                                                                                </defaultStyles>
                                                                                                <dataFormat><numberFormat decimalSize="0"/></dataFormat><CSS value="color:#454545"/></style>
                                                                                        </v2_axisLabels>
                                                                                        <v2_axisRange>
                                        <v2_automaticRange/>
                                    </v2_axisRange><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
                                                                                </v2_topLeftAxis>
                                                                                <style>
                                                                                    <CSS value="width:435px;height:140px;font-family:Arial;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
                                                                                
                                                                                <chartSuppress type="categories"/></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:5px;background-color:#F7F7F7;padding-bottom:5px"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:#F7F7F7;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center;background-color:#F7F7F7"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:#F7F7F7"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;width:100%;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>OCI License Status</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:5px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="License Status">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;height:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Site"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Site"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="License"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="License"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Available"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Available"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Used"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Status"/></dataSource></textItem></contents><conditionalStyleRefs><conditionalStyleRef refConditionalStyle="Conditional Style 1"/></conditionalStyleRefs></listColumnBody></listColumn></listColumns></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Data Source Status</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px;padding-bottom:5px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<block>
			<contents><list horizontalPagination="true" name="List2" refQuery="Failed Data Source Count" rowsPerPage="1000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Data Source"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Data Source"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Vendor"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Vendor"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Date"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Detail"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Detail"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
		<style><CSS value="width:450px;height:125px;overflow:auto"/></style></block></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;padding-bottom:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><queries><query name="Violations">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>select 
dwh_inventory.violation.since as 'Date',
datediff(NOW(), dwh_inventory.violation.since) as 'Age',
dwh_inventory.host.name as 'Host',
dwh_inventory.host.os as 'Host OS',
dwh_inventory.storage.name as 'Storage Name',
if(dwh_inventory.volume.name is null, dwh_inventory.violation.volumeName, dwh_inventory.volume.name) as 'Volume',
dwh_inventory.volume.capacityMB/1024 as 'Capacity GB',

case dwh_inventory.violation.type 
when 'EXIST_NOT_APPROVED' then 'Unauthorized Path' 
when 'APPROVE_NOT_EXIST' then 'Path Outage' 
when 'NO_SPF' then 'Single Point of Failure' 
when 'REDUNDANCY_VIOLATION' then 'Missing Redundancy' 
when 'HOPS_VIOLATION' then 'Switch Hop Count' 
when 'HOST_PORTS_VIOLATION' then 'Missing Active Host Ports' 
when 'SHARE_VOLUME_SCOPE_VIOLATION' then 'Unauthorized Sharing' 
when 'STORAGE_PORTS_VIOLATION' then 'Missing Active Storage Ports' 
when 'BACKEND_OUTAGE_VIOLATION' then 'Virtual Volume Missing Backend Support' 
when 'ISCSI_SECURITY_VIOLATION' then 'Missing Security' 
when 'ISCSI_NUMBER_OF_SESSIONS_VIOLATION' then 'Session Count' 
when 'ISCSI_NUMBER_OF_CONNECTIONS_VIOLATION' then 'Connection Count' 
when 'Hv_ACTIVE_PATH_CONFLICT_VIOLATION' then 'Active Path Conflict' 
when 'HV_MISSING_VIRTUAL_CLUSTER_PATH_VIOLATION' then 'Missing Virtual Cluster Paths' 
when 'HV_INCONSISTENT_LUNS_VIOLATION' then 'Inconsistent LUNs' 
when 'HV_MISSING_VIRTUAL_CLUSTER_NAS_PATH_VIOLATION' then 'Missing Virtual Cluster NAS Share' 
else dwh_inventory.violation.type
end as 'Type'

from	dwh_inventory.violation 

LEFT JOIN	dwh_inventory.host
ON	dwh_inventory.host.id=dwh_inventory.violation.hostid
LEFT JOIN	dwh_inventory.storage
ON	dwh_inventory.storage.id=dwh_inventory.violation.storageid
LEFT JOIN	dwh_inventory.volume
ON	dwh_inventory.volume.id=dwh_inventory.violation.volumeid





</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Age"/><mdProjectedItem name="Host"/><mdProjectedItem name="Host OS"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Capacity GB"/><mdProjectedItem name="Type"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem aggregate="maximum" name="Age"><expression>[SQL1].[Age]</expression></dataItem><dataItem name="Host"><expression>[SQL1].[Host]</expression></dataItem><dataItem name="Host OS"><expression>[SQL1].[Host OS]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem aggregate="total" name="Capacity GB"><expression>[SQL1].[Capacity GB]/1024</expression></dataItem><dataItem name="Type"><expression>[SQL1].[Type]</expression></dataItem><dataItem name="Date"><expression>_first_of_month([SQL1].[Date])</expression></dataItem><dataItem aggregate="total" name="Count"><expression>count([Type])</expression></dataItem></selection>
		</query><query name="Violation Count and Time Frame">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>select 
dwh_inventory.violation.since as 'Date',

count(case dwh_inventory.violation.type 
when 'EXIST_NOT_APPROVED' then 'Unauthorized Path' 
when 'APPROVE_NOT_EXIST' then 'Path Outage' 
when 'NO_SPF' then 'Single Point of Failure' 
when 'REDUNDANCY_VIOLATION' then 'Missing Redundancy' 
when 'HOPS_VIOLATION' then 'Switch Hop Count' 
when 'HOST_PORTS_VIOLATION' then 'Missing Active Host Ports' 
when 'SHARE_VOLUME_SCOPE_VIOLATION' then 'Unauthorized Sharing' 
when 'STORAGE_PORTS_VIOLATION' then 'Missing Active Storage Ports' 
when 'BACKEND_OUTAGE_VIOLATION' then 'Virtual Volume Missing Backend Support' 
when 'ISCSI_SECURITY_VIOLATION' then 'Missing Security' 
when 'ISCSI_NUMBER_OF_SESSIONS_VIOLATION' then 'Session Count' 
when 'ISCSI_NUMBER_OF_CONNECTIONS_VIOLATION' then 'Connection Count' 
when 'Hv_ACTIVE_PATH_CONFLICT_VIOLATION' then 'Active Path Conflict' 
when 'HV_MISSING_VIRTUAL_CLUSTER_PATH_VIOLATION' then 'Missing Virtual Cluster Paths' 
when 'HV_INCONSISTENT_LUNS_VIOLATION' then 'Inconsistent LUNs' 
when 'HV_MISSING_VIRTUAL_CLUSTER_NAS_PATH_VIOLATION' then 'Missing Virtual Cluster NAS Share' 
else dwh_inventory.violation.type
end) as 'Violation Count'

from	dwh_inventory.violation 

GROUP by dwh_inventory.violation.since</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Violation Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem aggregate="total" name="Violation Count"><expression>[SQL2].[Violation Count]</expression></dataItem><dataItem name="Total for Month"><expression>total([Violation Count] for month([Date]))</expression></dataItem><dataItem name="Month Name"><expression>MonthName([Date])</expression></dataItem><dataItem name="Month Number"><expression>Month([Date])</expression></dataItem></selection>
		</query><query name="Path Outage Trend">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>select 
dwh_inventory.violation.since as 'Date',

count(case dwh_inventory.violation.type 
when 'APPROVE_NOT_EXIST' then 'Path Outage' 
end) as 'Violation Count'

from	dwh_inventory.violation 

GROUP by dwh_inventory.violation.since</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Violation Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem aggregate="total" name="Violation Count"><expression>[SQL2].[Violation Count]</expression></dataItem><dataItem name="Total for Month"><expression>total([Violation Count] for month([Date]))</expression></dataItem><dataItem name="Month Name"><expression>MonthName([Date])</expression></dataItem><dataItem name="Month Number"><expression>Month([Date])</expression></dataItem><dataItem name="Total Violations" aggregate="total"><expression>total([Violation Count] for report)</expression></dataItem></selection>
		</query><query name="Violation Capacity Trends">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>select 
dwh_inventory.violation.since as 'Date',
dwh_inventory.volume.capacityMB/1024 as 'Capacity (GB)',
count(case dwh_inventory.violation.type 
when 'EXIST_NOT_APPROVED' then 'Unauthorized Path' 
when 'APPROVE_NOT_EXIST' then 'Path Outage' 
when 'NO_SPF' then 'Single Point of Failure' 
when 'REDUNDANCY_VIOLATION' then 'Missing Redundancy' 
when 'HOPS_VIOLATION' then 'Switch Hop Count' 
when 'HOST_PORTS_VIOLATION' then 'Missing Active Host Ports' 
when 'SHARE_VOLUME_SCOPE_VIOLATION' then 'Unauthorized Sharing' 
when 'STORAGE_PORTS_VIOLATION' then 'Missing Active Storage Ports' 
when 'BACKEND_OUTAGE_VIOLATION' then 'Virtual Volume Missing Backend Support' 
when 'ISCSI_SECURITY_VIOLATION' then 'Missing Security' 
when 'ISCSI_NUMBER_OF_SESSIONS_VIOLATION' then 'Session Count' 
when 'ISCSI_NUMBER_OF_CONNECTIONS_VIOLATION' then 'Connection Count' 
when 'Hv_ACTIVE_PATH_CONFLICT_VIOLATION' then 'Active Path Conflict' 
when 'HV_MISSING_VIRTUAL_CLUSTER_PATH_VIOLATION' then 'Missing Virtual Cluster Paths' 
when 'HV_INCONSISTENT_LUNS_VIOLATION' then 'Inconsistent LUNs' 
when 'HV_MISSING_VIRTUAL_CLUSTER_NAS_PATH_VIOLATION' then 'Missing Virtual Cluster NAS Share' 
else dwh_inventory.violation.type
end) as 'Violation Count'

from	dwh_inventory.violation 
JOIN 	dwh_inventory.volume
ON	dwh_inventory.volume.id=dwh_inventory.violation.volumeid


GROUP by dwh_inventory.violation.since, dwh_inventory.volume.id
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Capacity (GB)"/><mdProjectedItem name="Violation Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL2].[Date]</expression></dataItem><dataItem aggregate="total" name="Violation Count"><expression>[SQL2].[Violation Count]</expression></dataItem><dataItem name="Total for Month"><expression>total([Violation Count] for month([Date]))</expression></dataItem><dataItem name="Month Name"><expression>MonthName([Date])</expression></dataItem><dataItem name="Month Number"><expression>Month([Date])</expression></dataItem><dataItem aggregate="total" name="Capacity (GB)"><expression>[SQL2].[Capacity (GB)]/1024</expression></dataItem></selection>
		</query><query name="Capacity Thresholds Thin">
						<source>
							
						<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT 	dwh_capacity.storage_dimension.dataCenter AS 'Data Center',
	dwh_capacity.storage_dimension.manufacturer AS 'Manufacturer',
	dwh_capacity.tier_dimension.name AS 'Storage Tier',
	dwh_capacity.storage_dimension.model AS 'Model',
	dwh_capacity.storage_dimension.name AS 'Storage Name',
	ROUND((x.rawCapacityGB), 2) AS 'Raw Capacity (GB)',
	ROUND((x.capacityGB), 2) AS 'Usable (GB)',
	CASE 	WHEN	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.CapacityGB), 2)
		ELSE 	ROUND((x.volCapacityGB), 2)
		END 	'Allocated/Committed Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.CapacityGB)/(x.capacityGB), 2)
		ELSE 	ROUND((x.volCapacityGB)/(x.CapacityGB), 2)
		END 	'Allocated/Committed (%)',
	CASE 	WHEN	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((yThin.CapacityGB), 2)
		ELSE 	ROUND((xThin.volCapacityGB), 2)
		END 	'Thin Allocated/Committed Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((yThin.CapacityGB)/(x.capacityGB), 2)
		ELSE 	ROUND((xThin.volCapacityGB)/(x.CapacityGB), 2)
		END 	'Thin Allocated/Committed (%)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.PrimaryGB), 2)
		ELSE 	ROUND((x.volCapacityGB - z.ProtectionGB), 2)
		END 	'Primary Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.PrimaryGB)/(x.capacityGB), 2)
		ELSE 	ROUND((x.volCapacityGB - z.ProtectionGB)/(x.CapacityGB), 2)
		END 	'Primary Capacity (%)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.DRGB), 2)
		ELSE 	ROUND((z.ProtectionGB), 2)
		END 	'DR Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.DRGB)/(x.capacityGB), 2)
		ELSE 	ROUND((z.ProtectionGB)/(x.capacityGB), 2)
		END 	'DR Capacity (%)',
	ROUND((y.SavingsGB), 2) AS 'Dedupe Savings (GB)',
	ROUND((y.SavingsGB)/(x.capacityGB), 2) AS 'Dedupe Savings (%)',
	ROUND((x.usedCapacityGB), 2) AS 'Data Written (GB)',
	ROUND((x.usedCapacityGB)/(x.capacityGB), 2) AS '% Written',
	ROUND((x.capacityGB) - (x.usedCapacityGB), 2) AS 'Total Free (GB)',
	ROUND(((x.capacityGB) - (x.usedCapacityGB))/(x.capacityGB), 2) AS 'Total Free (%)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN 	dwh_capacity.storage_pool_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_Capacity.date_dimension.latest = 1
JOIN	(
	SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
		dwh_capacity.tier_dimension.tk TierTk,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024 rawCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024 capacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024 usedCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024 volCapacityGB
	FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
	JOIN 	dwh_Capacity.storage_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_Capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_Capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.tier_dimension.tk
	) X
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = x.StorageTk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = x.TierTk
LEFT JOIN 	(
	SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
		dwh_capacity.tier_dimension.tk TierTk,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024 rawCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024 capacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024 usedCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024 volCapacityGB
	FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
	JOIN 	dwh_Capacity.storage_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_Capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	AND 	dwh_capacity.storage_pool_dimension.thinProvisioningSupported = 1
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_Capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.tier_dimension.tk
	) xThin
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = xThin.StorageTk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = xThin.TierTk
LEFT JOIN
	(
	SELECT 	y1.StorageTk StorageTk,
		y1.TierTk TierTk,
		SUM(y1.CapacityGB) CapacityGB,
		SUM(y2.PrimaryGB) PrimaryGB,
		SUM(y3.DRGB) DRGB,
		SUM(y1.UsedCapacityGB) UsedCapacityGB,
		SUM(y1.SavingsGB) SavingsGB
	FROM 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 CapacityGB,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 UsedCapacityGB,
			dwh_capacity.internal_volume_capacity_fact.dedupeRatio Dedupe,
			(1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio DedupeSavingsRatio,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 * ((1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio) SavingsGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) y1
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 PrimaryGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType = 'N/A'
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) y2
	ON 	y1.tk = y2.tk
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 DRGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType &lt;&gt; 'N/A'
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) y3
	ON 	y1.tk = y3.tk
	GROUP BY y1.StorageTk, y1.TierTk
	) Y
ON 	dwh_capacity.storage_dimension.tk = y.StorageTk
AND 	dwh_capacity.tier_dimension.tk = y.TierTk
LEFT JOIN
	(
	SELECT 	yThin1.StorageTk StorageTk,
		yThin1.TierTk TierTk,
		SUM(yThin1.CapacityGB) CapacityGB,
		SUM(yThin2.PrimaryGB) PrimaryGB,
		SUM(yThin3.DRGB) DRGB,
		SUM(yThin1.UsedCapacityGB) UsedCapacityGB,
		SUM(yThin1.SavingsGB) SavingsGB
	FROM 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 CapacityGB,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 UsedCapacityGB,
			dwh_capacity.internal_volume_capacity_fact.dedupeRatio Dedupe,
			(1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio DedupeSavingsRatio,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 * ((1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio) SavingsGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_dimension.thinProvisioned = 1
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) yThin1
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 PrimaryGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType = 'N/A'
		AND 	dwh_capacity.internal_volume_dimension.thinProvisioned = 1
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) yThin2
	ON 	yThin1.tk = yThin2.tk
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 DRGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType &lt;&gt; 'N/A'
		AND 	dwh_capacity.internal_volume_dimension.thinProvisioned = 1
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) yThin3
	ON 	yThin1.tk = yThin3.tk
	GROUP BY yThin1.StorageTk, yThin1.TierTk
	) yThin
ON 	dwh_capacity.storage_dimension.tk = yThin.StorageTk
AND 	dwh_capacity.tier_dimension.tk = yThin.TierTk
LEFT JOIN
	(
	SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
		dwh_capacity.storage_dimension.name StorageName,
		dwh_capacity.tier_dimension.tk TierTk,
		dwh_capacity.tier_dimension.name TierName,
		SUM(dwh_capacity.volume_capacity_fact.provisionedCapacityMB)/1024 CapacityGB,
		SUM(dwh_capacity.volume_capacity_fact.provisionedCapacityMB)/1024 - SUM(dwh_capacity.volume_capacity_fact.protectionCapacityMB)/1024 PrimaryGB,
		SUM(CASE
			WHEN 	dwh_capacity.volume_capacity_fact.protectionCapacityMB IS NOT NULL
			THEN 	dwh_capacity.volume_capacity_fact.protectionCapacityMB/1024
			ELSE 	0
		END) 	ProtectionGB,
		SUM(dwh_capacity.volume_capacity_fact.orphanedCapacityMB)/1024 OrphanedGB,
		SUM(dwh_capacity.volume_capacity_fact.unusedCapacityMB)/1024 UnusedGB
	FROM 	dwh_capacity.volume_capacity_fact
	JOIN 	dwh_capacity.storage_dimension
	ON 	dwh_capacity.volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.storage_and_storage_pool_capacity_fact
	ON 	dwh_capacity.volume_capacity_fact.storageAndSpFactTk = dwh_capacity.storage_and_storage_pool_capacity_fact.tk
	GROUP BY 	dwh_capacity.storage_dimension.tk, dwh_capacity.tier_dimension.tk
	) z
ON 	dwh_capacity.storage_dimension.tk = z.StorageTk
AND 	dwh_capacity.tier_dimension.tk = z.TierTk
GROUP BY 	
	dwh_capacity.storage_dimension.dataCenter,
	dwh_capacity.storage_dimension.name,
	dwh_capacity.tier_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Storage Tier"/><mdProjectedItem name="Model"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Raw Capacity (GB)"/><mdProjectedItem name="Usable (GB)"/><mdProjectedItem name="Allocated/Committed Capacity (GB)"/><mdProjectedItem name="Allocated/Committed (%)"/><mdProjectedItem name="Thin Allocated/Committed Capacity (GB)"/><mdProjectedItem name="Thin Allocated/Committed (%)"/><mdProjectedItem name="Primary Capacity (GB)"/><mdProjectedItem name="Primary Capacity (%)"/><mdProjectedItem name="DR Capacity (GB)"/><mdProjectedItem name="DR Capacity (%)"/><mdProjectedItem name="Dedupe Savings (GB)"/><mdProjectedItem name="Dedupe Savings (%)"/><mdProjectedItem name="Data Written (GB)"/><mdProjectedItem name="% Written"/><mdProjectedItem name="Total Free (GB)"/><mdProjectedItem name="Total Free (%)"/></mdProjectedItems></sqlQuery></source>
						<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Storage Tier"><expression>[SQL1].[Storage Tier]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Raw Capacity (GB)"><expression>[SQL1].[Raw Capacity (GB)]</expression></dataItem><dataItem name="Usable (GB)"><expression>[SQL1].[Usable (GB)]</expression></dataItem><dataItem label="Allocated / Committed Capacity (GB)" name="Allocated/Committed Capacity (GB)"><expression>[SQL1].[Allocated/Committed Capacity (GB)]</expression></dataItem><dataItem label="Allocated / Committed (%)" name="Allocated/Committed (%)"><expression>[SQL1].[Allocated/Committed (%)]</expression></dataItem><dataItem label="Thin Allocated / Committed Capacity (GB)" name="Thin Allocated/Committed Capacity (GB)"><expression>[SQL1].[Thin Allocated/Committed Capacity (GB)]</expression></dataItem><dataItem aggregate="total" label="Thin Allocated / Committed (%)" name="Thin Allocated/Committed (%)"><expression>[SQL1].[Thin Allocated/Committed (%)]</expression></dataItem><dataItem name="Primary Capacity (GB)"><expression>[SQL1].[Primary Capacity (GB)]</expression></dataItem><dataItem name="Primary Capacity (%)"><expression>[SQL1].[Primary Capacity (%)]</expression></dataItem><dataItem name="DR Capacity (GB)"><expression>[SQL1].[DR Capacity (GB)]</expression></dataItem><dataItem name="DR Capacity (%)"><expression>[SQL1].[DR Capacity (%)]</expression></dataItem><dataItem name="Dedupe Savings (GB)"><expression>[SQL1].[Dedupe Savings (GB)]</expression></dataItem><dataItem name="Dedupe Savings (%)"><expression>[SQL1].[Dedupe Savings (%)]</expression></dataItem><dataItem name="Data Written (GB)"><expression>[SQL1].[Data Written (GB)]</expression></dataItem><dataItem name="% Written"><expression>[SQL1].[% Written]</expression></dataItem><dataItem name="Total Free (GB)"><expression>[SQL1].[Total Free (GB)]</expression></dataItem><dataItem name="Total Free (%)"><expression>[SQL1].[Total Free (%)]</expression></dataItem></selection>
					</query><query name="Capacity Thresholds">
						<source>
							
						<sqlQuery dataSource="dwh_capacity" name="SQL1">
			<sqlText>SELECT 	dwh_capacity.storage_dimension.dataCenter AS 'Data Center',
	dwh_capacity.storage_dimension.manufacturer AS 'Manufacturer',
	dwh_capacity.tier_dimension.name AS 'Storage Tier',
	dwh_capacity.storage_dimension.model AS 'Model',
	dwh_capacity.storage_dimension.name AS 'Storage Name',
	ROUND((x.rawCapacityGB), 2) AS 'Raw Capacity (GB)',
	ROUND((x.capacityGB), 2) AS 'Usable (GB)',
	CASE 	WHEN	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.CapacityGB), 2)
		ELSE 	ROUND((x.volCapacityGB), 2)
		END 	'Allocated/Committed Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.CapacityGB)/(x.capacityGB), 2)
		ELSE 	ROUND((x.volCapacityGB)/(x.CapacityGB), 2)
		END 	'Allocated/Committed (%)',
	CASE 	WHEN	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((yThin.CapacityGB), 2)
		ELSE 	ROUND((xThin.volCapacityGB), 2)
		END 	'Thin Allocated/Committed Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((yThin.CapacityGB)/(x.capacityGB), 2)
		ELSE 	ROUND((xThin.volCapacityGB)/(x.CapacityGB), 2)
		END 	'Thin Allocated/Committed (%)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.PrimaryGB), 2)
		ELSE 	ROUND((x.volCapacityGB - z.ProtectionGB), 2)
		END 	'Primary Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.PrimaryGB)/(x.capacityGB), 2)
		ELSE 	ROUND((x.volCapacityGB - z.ProtectionGB)/(x.CapacityGB), 2)
		END 	'Primary Capacity (%)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.DRGB), 2)
		ELSE 	ROUND((z.ProtectionGB), 2)
		END 	'DR Capacity (GB)',
	CASE 	WHEN 	dwh_capacity.storage_dimension.manufacturer = 'NetApp'
		THEN 	ROUND((y.DRGB)/(x.capacityGB), 2)
		ELSE 	ROUND((z.ProtectionGB)/(x.capacityGB), 2)
		END 	'DR Capacity (%)',
	ROUND((y.SavingsGB), 2) AS 'Dedupe Savings (GB)',
	ROUND((y.SavingsGB)/(x.capacityGB), 2) AS 'Dedupe Savings (%)',
	ROUND((x.usedCapacityGB), 2) AS 'Data Written (GB)',
	ROUND((x.usedCapacityGB)/(x.capacityGB), 2) AS '% Written',
	ROUND((x.capacityGB) - (x.usedCapacityGB), 2) AS 'Total Free (GB)',
	ROUND(((x.capacityGB) - (x.usedCapacityGB))/(x.capacityGB), 2) AS 'Total Free (%)'
FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
JOIN 	dwh_capacity.storage_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
JOIN 	dwh_capacity.storage_pool_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
JOIN 	dwh_capacity.tier_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
JOIN 	dwh_capacity.date_dimension
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
AND 	dwh_Capacity.date_dimension.latest = 1
JOIN	(
	SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
		dwh_capacity.tier_dimension.tk TierTk,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024 rawCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024 capacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024 usedCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024 volCapacityGB
	FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
	JOIN 	dwh_Capacity.storage_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_Capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_Capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.tier_dimension.tk
	) X
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = x.StorageTk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = x.TierTk
LEFT JOIN 	(
	SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
		dwh_capacity.tier_dimension.tk TierTk,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.rawCapacityMB)/1024 rawCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.capacityMB)/1024 capacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.usedCapacityMB)/1024 usedCapacityGB,
		SUM(dwh_capacity.storage_and_storage_pool_capacity_fact.volumeCapacityMB)/1024 volCapacityGB
	FROM 	dwh_capacity.storage_and_storage_pool_capacity_fact
	JOIN 	dwh_Capacity.storage_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = dwh_Capacity.storage_dimension.tk
	JOIN 	dwh_capacity.storage_pool_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storagePoolTk = dwh_capacity.storage_pool_dimension.tk
	AND 	dwh_capacity.storage_pool_dimension.thinProvisioningSupported = 1
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.date_dimension
	ON 	dwh_Capacity.storage_and_storage_pool_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
	AND 	dwh_capacity.date_dimension.latest = 1
	GROUP BY dwh_capacity.storage_dimension.tk, dwh_capacity.tier_dimension.tk
	) xThin
ON 	dwh_capacity.storage_and_storage_pool_capacity_fact.storageTk = xThin.StorageTk
AND 	dwh_capacity.storage_and_storage_pool_capacity_fact.tierTk = xThin.TierTk
LEFT JOIN
	(
	SELECT 	y1.StorageTk StorageTk,
		y1.TierTk TierTk,
		SUM(y1.CapacityGB) CapacityGB,
		SUM(y2.PrimaryGB) PrimaryGB,
		SUM(y3.DRGB) DRGB,
		SUM(y1.UsedCapacityGB) UsedCapacityGB,
		SUM(y1.SavingsGB) SavingsGB
	FROM 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 CapacityGB,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 UsedCapacityGB,
			dwh_capacity.internal_volume_capacity_fact.dedupeRatio Dedupe,
			(1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio DedupeSavingsRatio,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 * ((1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio) SavingsGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) y1
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 PrimaryGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType = 'N/A'
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) y2
	ON 	y1.tk = y2.tk
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 DRGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType &lt;&gt; 'N/A'
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) y3
	ON 	y1.tk = y3.tk
	GROUP BY y1.StorageTk, y1.TierTk
	) Y
ON 	dwh_capacity.storage_dimension.tk = y.StorageTk
AND 	dwh_capacity.tier_dimension.tk = y.TierTk
LEFT JOIN
	(
	SELECT 	yThin1.StorageTk StorageTk,
		yThin1.TierTk TierTk,
		SUM(yThin1.CapacityGB) CapacityGB,
		SUM(yThin2.PrimaryGB) PrimaryGB,
		SUM(yThin3.DRGB) DRGB,
		SUM(yThin1.UsedCapacityGB) UsedCapacityGB,
		SUM(yThin1.SavingsGB) SavingsGB
	FROM 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 CapacityGB,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 UsedCapacityGB,
			dwh_capacity.internal_volume_capacity_fact.dedupeRatio Dedupe,
			(1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio DedupeSavingsRatio,
			dwh_capacity.internal_volume_capacity_fact.usedCapacityMB/1024 * ((1 - dwh_capacity.internal_volume_capacity_fact.dedupeRatio)/dwh_capacity.internal_volume_capacity_fact.dedupeRatio) SavingsGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_dimension.thinProvisioned = 1
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) yThin1
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 PrimaryGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType = 'N/A'
		AND 	dwh_capacity.internal_volume_dimension.thinProvisioned = 1
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) yThin2
	ON 	yThin1.tk = yThin2.tk
	LEFT JOIN 	(
		SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
			dwh_capacity.tier_dimension.tk TierTk,
			dwh_capacity.internal_volume_dimension.tk,
			dwh_capacity.internal_volume_capacity_fact.allocatedCapacityMB/1024 DRGB
		FROM 	dwh_capacity.internal_volume_capacity_fact
		JOIN 	dwh_capacity.storage_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
		JOIN 	dwh_capacity.internal_volume_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.internalVolumeTk = dwh_capacity.internal_volume_dimension.tk
		AND 	dwh_capacity.internal_volume_capacity_fact.protectionType &lt;&gt; 'N/A'
		AND 	dwh_capacity.internal_volume_dimension.thinProvisioned = 1
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.internal_volume_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		GROUP BY dwh_capacity.internal_volume_dimension.tk
		) yThin3
	ON 	yThin1.tk = yThin3.tk
	GROUP BY yThin1.StorageTk, yThin1.TierTk
	) yThin
ON 	dwh_capacity.storage_dimension.tk = yThin.StorageTk
AND 	dwh_capacity.tier_dimension.tk = yThin.TierTk
LEFT JOIN
	(
	SELECT 	dwh_capacity.storage_dimension.tk StorageTk,
		dwh_capacity.storage_dimension.name StorageName,
		dwh_capacity.tier_dimension.tk TierTk,
		dwh_capacity.tier_dimension.name TierName,
		SUM(dwh_capacity.volume_capacity_fact.provisionedCapacityMB)/1024 CapacityGB,
		SUM(dwh_capacity.volume_capacity_fact.provisionedCapacityMB)/1024 - SUM(dwh_capacity.volume_capacity_fact.protectionCapacityMB)/1024 PrimaryGB,
		SUM(CASE
			WHEN 	dwh_capacity.volume_capacity_fact.protectionCapacityMB IS NOT NULL
			THEN 	dwh_capacity.volume_capacity_fact.protectionCapacityMB/1024
			ELSE 	0
		END) 	ProtectionGB,
		SUM(dwh_capacity.volume_capacity_fact.orphanedCapacityMB)/1024 OrphanedGB,
		SUM(dwh_capacity.volume_capacity_fact.unusedCapacityMB)/1024 UnusedGB
	FROM 	dwh_capacity.volume_capacity_fact
	JOIN 	dwh_capacity.storage_dimension
	ON 	dwh_capacity.volume_capacity_fact.storageTk = dwh_capacity.storage_dimension.tk
	JOIN 	dwh_capacity.tier_dimension
	ON 	dwh_capacity.volume_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
	JOIN 	dwh_capacity.storage_and_storage_pool_capacity_fact
	ON 	dwh_capacity.volume_capacity_fact.storageAndSpFactTk = dwh_capacity.storage_and_storage_pool_capacity_fact.tk
	GROUP BY 	dwh_capacity.storage_dimension.tk, dwh_capacity.tier_dimension.tk
	) z
ON 	dwh_capacity.storage_dimension.tk = z.StorageTk
AND 	dwh_capacity.tier_dimension.tk = z.TierTk
GROUP BY 	
	dwh_capacity.storage_dimension.dataCenter,
	dwh_capacity.storage_dimension.name,
	dwh_capacity.tier_dimension.name</sqlText>
		<mdProjectedItems><mdProjectedItem name="Data Center"/><mdProjectedItem name="Manufacturer"/><mdProjectedItem name="Storage Tier"/><mdProjectedItem name="Model"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Raw Capacity (GB)"/><mdProjectedItem name="Usable (GB)"/><mdProjectedItem name="Allocated/Committed Capacity (GB)"/><mdProjectedItem name="Allocated/Committed (%)"/><mdProjectedItem name="Thin Allocated/Committed Capacity (GB)"/><mdProjectedItem name="Thin Allocated/Committed (%)"/><mdProjectedItem name="Primary Capacity (GB)"/><mdProjectedItem name="Primary Capacity (%)"/><mdProjectedItem name="DR Capacity (GB)"/><mdProjectedItem name="DR Capacity (%)"/><mdProjectedItem name="Dedupe Savings (GB)"/><mdProjectedItem name="Dedupe Savings (%)"/><mdProjectedItem name="Data Written (GB)"/><mdProjectedItem name="% Written"/><mdProjectedItem name="Total Free (GB)"/><mdProjectedItem name="Total Free (%)"/></mdProjectedItems></sqlQuery></source>
						<selection><dataItem name="Data Center"><expression>[SQL1].[Data Center]</expression></dataItem><dataItem name="Manufacturer"><expression>[SQL1].[Manufacturer]</expression></dataItem><dataItem name="Storage Tier"><expression>[SQL1].[Storage Tier]</expression></dataItem><dataItem name="Model"><expression>[SQL1].[Model]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Raw Capacity (GB)"><expression>[SQL1].[Raw Capacity (GB)]</expression></dataItem><dataItem name="Usable (GB)"><expression>[SQL1].[Usable (GB)]</expression></dataItem><dataItem label="Allocated / Committed Capacity (GB)" name="Allocated/Committed Capacity (GB)"><expression>[SQL1].[Allocated/Committed Capacity (GB)]</expression></dataItem><dataItem label="Allocated / Committed (%)" name="Allocated/Committed (%)"><expression>[SQL1].[Allocated/Committed (%)]</expression></dataItem><dataItem label="Thin Allocated / Committed Capacity (GB)" name="Thin Allocated/Committed Capacity (GB)"><expression>[SQL1].[Thin Allocated/Committed Capacity (GB)]</expression></dataItem><dataItem name="Primary Capacity (GB)"><expression>[SQL1].[Primary Capacity (GB)]</expression></dataItem><dataItem name="Primary Capacity (%)"><expression>[SQL1].[Primary Capacity (%)]</expression></dataItem><dataItem name="DR Capacity (GB)"><expression>[SQL1].[DR Capacity (GB)]</expression></dataItem><dataItem name="DR Capacity (%)"><expression>[SQL1].[DR Capacity (%)]</expression></dataItem><dataItem name="Dedupe Savings (GB)"><expression>[SQL1].[Dedupe Savings (GB)]</expression></dataItem><dataItem name="Dedupe Savings (%)"><expression>[SQL1].[Dedupe Savings (%)]</expression></dataItem><dataItem name="Data Written (GB)"><expression>[SQL1].[Data Written (GB)]</expression></dataItem><dataItem aggregate="total" name="% Written"><expression>[SQL1].[% Written]</expression></dataItem><dataItem name="Total Free (GB)"><expression>[SQL1].[Total Free (GB)]</expression></dataItem><dataItem name="Total Free (%)"><expression>[SQL1].[Total Free (%)]</expression></dataItem></selection>
					<detailFilters><detailFilter><filterExpression>[% Written]&gt;=.9</filterExpression></detailFilter></detailFilters></query><query name="High Fan Out">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL1">
			<sqlText>
Select 
	Storage.datacenter,
	Host.HostName,
	Host.HostIP,
	Host.HostPortWWN,
	Host.HostSwitchPortStatus,
	Host.HostSwitchName,
	Host.HostSwitchPortName,
                     Host.HostSwitchPortNumber,
	Host.HostSwitchPortWWN,
	Storage.StorageName,
	Storage.StoragePortName,
	Storage.StoragePortWWN,
	Storage.StorageSwitchPortStatus,
	Storage.StorageSwitchName,
	Storage.StorageSwitchPortName,
                     Storage.StorageSwitchPortNumber,
	Storage.StorageSwitchPortWWN

From

(select 
		ht.id as HostID,
		ht.name as HostName,
		ht.ip as HostIP,
		hp.wwn as HostPortWWN,
		hp.id as HostPortID,
		pc.connectedID,
		pc.connectedWwn,
		sw.id as HostSwitchID,
		sw.name as HostSwitchName,
		swp.id as HostSwitchPortID,
		swp.name as HostSwitchPortName,
                                           swp.number as HostSwitchPortNumber,
		swp.wwn as HostSwitchPortWWN,
		swp.status as HostSwitchPortStatus,
		zm.zoneId as ZoneID

from 
		dwh_inventory.host_port as hp,
		dwh_inventory.port_connectivity as pc,
		dwh_inventory.host as ht,
		dwh_inventory.switch_port as swp,
		dwh_inventory.switch as sw,
		dwh_inventory.zone_member as zm

where 	hp.wwn = pc.wwn
and 	ht.id = hp.hostid
and 	swp.id = pc.connectedID
and 	swp.switchid = sw.id
and     zm.wwn = hp.wwn) Host join 

(select 
		st.datacenter,
		st.id as StorageID,
		st.name as StorageName,
		sp.name as StoragePortName,
		sp.wwn as StoragePortWWN,
		sp.id as StoragePortID,
		pc.connectedID,
		pc.connectedWwn,
		sw.id as StorageSwitchID,
		sw.name as StorageSwitchName,
		swp.id as StorageSwitchPortID,
		swp.name as StorageSwitchPortName,
		swp.wwn as StorageSwitchPortWWN,
		swp.number as StorageSwitchPortNumber,
		swp.status as StorageSwitchPortStatus,
		zm.zoneId as ZoneID

from 
		dwh_inventory.storage_port as sp,
		dwh_inventory.port_connectivity as pc,
		dwh_inventory.storage as st,
		dwh_inventory.switch_port as swp,
		dwh_inventory.switch as sw,
		dwh_inventory.zone_member as zm

where 	sp.wwn = pc.wwn
and 	st.id = sp.storageid
and 	swp.id = pc.connectedID
and 	swp.switchid = sw.id
and     zm.wwn = sp.wwn) Storage on host.ZoneID = Storage.ZoneID</sqlText>
		<mdProjectedItems><mdProjectedItem name="datacenter"/><mdProjectedItem name="HostName"/><mdProjectedItem name="HostIP"/><mdProjectedItem name="HostPortWWN"/><mdProjectedItem name="HostSwitchPortStatus"/><mdProjectedItem name="HostSwitchName"/><mdProjectedItem name="HostSwitchPortName"/><mdProjectedItem name="HostSwitchPortNumber"/><mdProjectedItem name="HostSwitchPortWWN"/><mdProjectedItem name="StorageName"/><mdProjectedItem name="StoragePortName"/><mdProjectedItem name="StoragePortWWN"/><mdProjectedItem name="StorageSwitchPortStatus"/><mdProjectedItem name="StorageSwitchName"/><mdProjectedItem name="StorageSwitchPortName"/><mdProjectedItem name="StorageSwitchPortNumber"/><mdProjectedItem name="StorageSwitchPortWWN"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="datacenter"><expression>[SQL1].[datacenter]</expression></dataItem><dataItem name="HostName"><expression>[SQL1].[HostName]</expression></dataItem><dataItem name="HostIP"><expression>[SQL1].[HostIP]</expression></dataItem><dataItem name="HostPortWWN"><expression>[SQL1].[HostPortWWN]</expression></dataItem><dataItem name="HostSwitchPortStatus"><expression>[SQL1].[HostSwitchPortStatus]</expression></dataItem><dataItem name="HostSwitchName"><expression>[SQL1].[HostSwitchName]</expression></dataItem><dataItem name="HostSwitchPortName"><expression>[SQL1].[HostSwitchPortName]</expression></dataItem><dataItem name="HostSwitchPortNumber"><expression>[SQL1].[HostSwitchPortNumber]</expression></dataItem><dataItem name="HostSwitchPortWWN"><expression>[SQL1].[HostSwitchPortWWN]</expression></dataItem><dataItem name="StorageName"><expression>[SQL1].[StorageName]</expression></dataItem><dataItem name="StoragePortName"><expression>[SQL1].[StoragePortName]</expression></dataItem><dataItem name="StoragePortWWN"><expression>[SQL1].[StoragePortWWN]</expression></dataItem><dataItem name="StorageSwitchPortStatus"><expression>[SQL1].[StorageSwitchPortStatus]</expression></dataItem><dataItem name="StorageSwitchName"><expression>[SQL1].[StorageSwitchName]</expression></dataItem><dataItem name="StorageSwitchPortName"><expression>[SQL1].[StorageSwitchPortName]</expression></dataItem><dataItem name="StorageSwitchPortNumber"><expression>[SQL1].[StorageSwitchPortNumber]</expression></dataItem><dataItem name="StorageSwitchPortWWN"><expression>[SQL1].[StorageSwitchPortWWN]</expression></dataItem><dataItem name="Fan Out"><expression>count([SQL1].[HostPortWWN] for [SQL1].[StoragePortWWN])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Fan Out]&gt;12</filterExpression></detailFilter></detailFilters></query><query name="RepCatalog Perf">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL4">
			<sqlText>SELECT
dwh_custom.pool_perf_fact.avgIOpS as 'Total IOpS',
dwh_custom.pool_perf_fact.totalresponsetime as 'Avg Latency (ms)',
dwh_custom.pool_perf_fact.totalthroughput as 'Throughput (MB/sec)',
dwh_custom.pool_perf_fact.fulldate as 'Full Date'

FROM dwh_custom.pool_perf_fact

GROUP BY dwh_custom.pool_perf_fact.fulldate
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Avg Latency (ms)"/><mdProjectedItem name="Throughput (MB/sec)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem aggregate="total" name="Total IOpS"><expression>[SQL4].[Total IOpS]</expression></dataItem><dataItem aggregate="average" name="Avg Latency (ms)"><expression>[SQL4].[Avg Latency (ms)]</expression></dataItem><dataItem aggregate="total" name="Throughput (MB/sec)"><expression>[SQL4].[Throughput (MB/sec)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL4].[Full Date]</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints></query><query name="Failed Data Source Count">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT

SUM(IF(dwh_inventory.acq_data_source.auditLastStatusMessage NOT LIKE 'Success', 1, 0)) as 'Failed Count',

dwh_inventory.acq_data_source.name as 'Data Source',
dwh_inventory.acq_data_source.vendor as 'Vendor',
dwh_inventory.acq_data_source.auditStatusDate as 'Date',
SUBSTRING(auditLastStatusMessage,1,200) as 'Status',
SUBSTRING(additionalDataSourceMessage,1,200) as 'Detail'


FROM dwh_inventory.acq_data_source

GROUP BY dwh_inventory.acq_data_source.name </sqlText>
		<mdProjectedItems><mdProjectedItem name="Failed Count"/><mdProjectedItem name="Data Source"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Date"/><mdProjectedItem name="Status"/><mdProjectedItem name="Detail"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Failed Count"><expression>[SQL3].[Failed Count]</expression></dataItem><dataItem name="Data Source"><expression>[SQL3].[Data Source]</expression></dataItem><dataItem name="Vendor"><expression>[SQL3].[Vendor]</expression></dataItem><dataItem name="Date"><expression>[SQL3].[Date]</expression></dataItem><dataItem name="Status"><expression>[SQL3].[Status]</expression></dataItem><dataItem name="Detail"><expression>[SQL3].[Detail]</expression></dataItem></selection>
		</query><query name="License Status"><source><sqlQuery name="SQL5" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
dwh_inventory.license_details.siteName as 'Site',
dwh_inventory.license_details.protocolCodeDisplayName as 'License',
dwh_inventory.license_details.quantity as 'Available',
dwh_inventory.license_details.actualQuantity as 'Used',
IF(dwh_inventory.license_details.actualQuantity&gt;dwh_inventory.license_details.quantity, 'Not Compliant', 'Compliant') as 'Status'

FROM dwh_inventory.license_details</sqlText>
		<mdProjectedItems><mdProjectedItem name="Site"/><mdProjectedItem name="License"/><mdProjectedItem name="Available"/><mdProjectedItem name="Used"/><mdProjectedItem name="Status"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Site"><expression>[SQL5].[Site]</expression></dataItem><dataItem name="License"><expression>[SQL5].[License]</expression></dataItem><dataItem name="Available"><expression>[SQL5].[Available]</expression></dataItem><dataItem name="Used"><expression>[SQL5].[Used]</expression></dataItem><dataItem name="Status"><expression>[SQL5].[Status]</expression></dataItem></selection></query><query name="Storage Pool Capacity Violations">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT

COUNT(*) as 'Count',
dwh_inventory.storage.name as 'Storage',
SUBSTRING_INDEX(dwh_inventory.storage_pool.name,':',1) as 'Pool',
dwh_inventory.storage_pool.totalUsedCapacityMB / dwh_inventory.storage_pool.totalAllocatedCapacityMB as '% Used'

FROM dwh_inventory.storage
JOIN dwh_inventory.storage_pool ON dwh_inventory.storage.id=dwh_inventory.storage_pool.storageid

WHERE dwh_inventory.storage_pool.totalUsedCapacityMB / dwh_inventory.storage_pool.totalAllocatedCapacityMB &gt; .9

GROUP BY dwh_inventory.storage.id, dwh_inventory.storage_pool.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="Count"/><mdProjectedItem name="Storage"/><mdProjectedItem name="Pool"/><mdProjectedItem name="% Used"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Count" aggregate="total"><expression>[SQL6].[Count]</expression></dataItem><dataItem name="Storage"><expression>[SQL6].[Storage]</expression></dataItem><dataItem name="Pool"><expression>[SQL6].[Pool]</expression></dataItem><dataItem name="% Used" aggregate="total"><expression>[SQL6].[% Used]</expression></dataItem></selection>
		</query><query name="Volume Performance Violations">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
SUM(IF(dwh_performance.volume_dimension.id &gt; 0, 1, 0)) as 'Volume Count',
SUBSTRING_INDEX(dwh_performance.volume_dimension.name,':',-1) as 'Volume',
ROUND(dwh_performance.volume_daily_performance_fact.totalresponsetime,2) as 'Latency'

FROM dwh_performance.volume_daily_performance_fact
JOIN dwh_performance.volume_dimension
ON   dwh_performance.volume_dimension.tk=dwh_performance.volume_daily_performance_fact.volumetk
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.volume_daily_performance_fact 
ON dwh_performance.volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 30 DAY
AND
dwh_performance.volume_daily_performance_fact.totalresponsetime &gt; 50

GROUP BY dwh_performance.volume_dimension.id

UNION

SELECT
SUM(IF(dwh_performance.internal_volume_dimension.id &gt; 0, 1, 0)) as 'Volume Count',

SUBSTRING_INDEX(dwh_performance.internal_volume_dimension.name,':',-1) as 'Volume',
ROUND(dwh_performance.internal_volume_daily_performance_fact.totalresponsetime,2) as 'Latency'

FROM dwh_performance.internal_volume_daily_performance_fact
JOIN dwh_performance.internal_volume_dimension
ON   dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.internalvolumetk
JOIN dwh_performance.date_dimension
ON   dwh_performance.date_dimension.tk=dwh_performance.internal_volume_daily_performance_fact.datetk

WHERE dwh_performance.date_dimension.fullDate &gt;= (SELECT MAX(dwh_performance.date_dimension.fullDate) 
FROM dwh_performance.date_dimension JOIN dwh_performance.internal_volume_daily_performance_fact 
ON dwh_performance.internal_volume_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk) - INTERVAL 30 DAY
AND
dwh_performance.internal_volume_daily_performance_fact.totalresponsetime &gt; 50

GROUP BY dwh_performance.internal_volume_dimension.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume Count"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Latency"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL7].[Volume]</expression></dataItem><dataItem name="Latency" aggregate="average"><expression>[SQL7].[Latency]</expression></dataItem><dataItem name="Volume Count" aggregate="total"><expression>[SQL7].[Volume Count]</expression></dataItem></selection>
		</query><query name="Switch Perf">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT
dwh_performance.switch_dimension.name as 'Port Switch',
dwh_performance.port_dimension.name as 'Port',
dwh_performance.switch_performance_for_port_hourly_fact.connectivityType as 'Connection Type',
dwh_performance.connected_device_dimension.name as 'Connected Device',
dwh_performance.connected_device_dimension.type 'Device Type',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.rxTraffic,0) as 'Rx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.txTraffic,0) as 'Tx Traffic',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0) as 'bbCreditZeroRx',
ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTx',

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx,0)+ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx,0) as 'bbCreditZeroTotal', 

ROUND(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx,0) as 'bbCreditZeroMsTx',
dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount as 'Class 3 Discard'


FROM dwh_performance.switch_performance_for_port_hourly_fact
JOIN dwh_performance.time_dimension
ON dwh_performance.time_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.timetk
JOIN dwh_performance.connected_device_dimension
ON dwh_performance.connected_device_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.connecteddevicetk
AND dwh_performance.connected_device_dimension.name is not null 
AND dwh_performance.connected_device_dimension.name &lt;&gt; 'N/A'
JOIN dwh_performance.switch_dimension
ON dwh_performance.switch_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.switchtk
JOIN dwh_performance.port_dimension
ON dwh_performance.port_dimension.tk=dwh_performance.switch_performance_for_port_hourly_fact.porttk

WHERE dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx &gt; 1000000
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx &gt; 1000000 
OR dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx &gt; 1

GROUP BY dwh_performance.switch_dimension.name, dwh_performance.port_dimension.name

</sqlText>
		<mdProjectedItems><mdProjectedItem name="Port Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Connection Type"/><mdProjectedItem name="Connected Device"/><mdProjectedItem name="Device Type"/><mdProjectedItem name="Rx Traffic"/><mdProjectedItem name="Tx Traffic"/><mdProjectedItem name="bbCreditZeroRx"/><mdProjectedItem name="bbCreditZeroTx"/><mdProjectedItem name="bbCreditZeroTotal"/><mdProjectedItem name="bbCreditZeroMsTx"/><mdProjectedItem name="Class 3 Discard"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Port Switch" label="Switch"><expression>[SQL3].[Port Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL3].[Port]</expression></dataItem><dataItem name="Connection Type"><expression>[SQL3].[Connection Type]</expression></dataItem><dataItem name="Connected Device"><expression>[SQL3].[Connected Device]</expression></dataItem><dataItem name="Device Type"><expression>[SQL3].[Device Type]</expression></dataItem><dataItem name="Rx Traffic"><expression>[SQL3].[Rx Traffic]</expression></dataItem><dataItem name="Tx Traffic"><expression>[SQL3].[Tx Traffic]</expression></dataItem><dataItem name="bbCreditZeroRx"><expression>[SQL3].[bbCreditZeroRx]</expression></dataItem><dataItem name="bbCreditZeroTx"><expression>[SQL3].[bbCreditZeroTx]</expression></dataItem><dataItem name="bbCreditZeroMsTx"><expression>[SQL3].[bbCreditZeroMsTx]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL3].[Class 3 Discard]</expression></dataItem><dataItem name="bbCreditZeroTotal" aggregate="total"><expression>[SQL3].[bbCreditZeroTotal]/1000/1000</expression></dataItem><dataItem name="Slow Drain Device Count" aggregate="total"><expression>COUNT(DISTINCT [Connected Device] for Report)</expression></dataItem><dataItem name="Slow Drain Port Count" aggregate="total"><expression>COUNT(DISTINCT [Port] for Report)</expression></dataItem><dataItem name="Average Rx Traffic"><expression>average([Rx Traffic] for report)/1000</expression></dataItem><dataItem name="Average Tx Traffic"><expression>average([Tx Traffic] for report)/1000</expression></dataItem><dataItem name="Peak bbCreditZeroRx"><expression>maximum([bbCreditZeroRx] for report)/1000/1000</expression></dataItem><dataItem name="Peak bbCreditZeroTx"><expression>maximum([bbCreditZeroTx] for report)/1000/1000</expression></dataItem></selection>
		</query></queries><reportName>7.1 Violation Trends and Status</reportName><reportVariables><reportVariable type="boolean" name="showPathOutageNote">
			<reportExpression>[Path Outage Trend].[Total Violations]=0</reportExpression>
			<variableValues>
				<variableValue value="1"/>
			</variableValues>
		</reportVariable></reportVariables><namedConditionalStyles><advancedConditionalStyle name="Conditional Style 1"><styleCases><styleCase><style><CSS value="background-color:#9AD7CD"/></style><reportCondition>[License Status].[Status]='Compliant'</reportCondition></styleCase></styleCases><styleDefault><style><CSS value="background-color:#FFB2C1"/></style></styleDefault></advancedConditionalStyle></namedConditionalStyles></report>